SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.DnnProduct_UpdatePortalAlias
	@PortalAliasID			int,
	@PortalID				int,
	@HTTPAlias				nvarchar(200),
	@LastModifiedByUserID	int

AS

UPDATE dbo.DnnProduct_PortalAlias 
SET HTTPAlias = @HTTPAlias,
	LastModifiedByUserID = @LastModifiedByUserID,
	LastModifiedOnDate = getdate()
WHERE PortalID = @PortalID
AND	  PortalAliasID = @PortalAliasID
GO
